package com.scoressystem.mapper;

import com.scoressystem.pojo.Scores;
import com.scoressystem.pojo.Subjects;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface ScoresMapper {

    List<Scores> selectAllScoresByPage(Map<String, Object> map);

    long selectAllScoresCount(Map<String, Object> map);

    int deleteScoreById(Integer id);

    List<Scores> getAllScoresBySname(String stuName);

    int addScore(Scores Score);

    Scores getScoreById(Integer id);

    int updateScore(Scores score);

    Scores getScoreByStuIdAndSubId(@Param("stuId") Integer stuId, @Param("subId") Integer subId);

    double getScoresByStuId(Integer stuId);

    List<Scores> getMyAllSubjectsByStuId(@Param("stuId") Integer stuId);
}
